﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="select.aspx.cs" Inherits="book_select" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
    <link href="../css/addbook.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
        .auto-style1 {
            width: 100px;
        }
        .auto-style2 {
            width: 140px;
        }
        .auto-style3 {
            width: 148px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
       <center>
        <div class="wrap">
	<div class="top">
    	<div class="top1">
        
           
        </div>
        
     </div>
            
        
    <div class="shortnfo">
         <h2>当前位置：订单管理->订单查询</h2>
     <div class="menuitems">
        
       

           <ul>
                      <li><a href="../master/index.aspx" runat="server">首页</a></li>
                       
                      <li><a  href="~/order/updateorder.aspx" runat="server">修改订单</a></li>
                      <li><a   href="~/order/delete.aspx" runat="server">订单回收</a></li>
                      <li><a href="../master/order.aspx">退出</a></li>
                  </ul>
         
     </div>
    </div>

<div class="content">
     <table border="0" style="table-layout:fixed;width:100%;text-align:left;height:100%" >
         <tr>
             <td class="auto-style1">订单号：</td>
             <td class="auto-style3">
                 <asp:TextBox ID="ordernum" runat="server"></asp:TextBox>
             </td>
           
             <td class="auto-style2">
                 订单状态：<br />

             </td>
             <td colspan="2">

                 <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1" DataTextField="状态" DataValueField="状态">
                 </asp:DropDownList>

                 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString5 %>" ProviderName="<%$ ConnectionStrings:ConnectionString5.ProviderName %>" SelectCommand="select * from orderdetails"></asp:SqlDataSource>

             </td>
             
             
         </tr>
         <tr>
             <td class="auto-style1">商品名称：</td>
             <td class="auto-style3">
                 <asp:TextBox ID="ordername" runat="server"></asp:TextBox>
             </td>
             <td class="auto-style2">付款日期：</td>
             <td class="auto-style3">
                 <asp:TextBox ID="orderdate" runat="server"></asp:TextBox>
             </td>
             <td>
                 <asp:Button ID="Button1" runat="server" Text="搜索" OnClick="Button1_Click" />
             </td>
         </tr>
  <tr>
      <td colspan="5">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="订单号" AllowPaging="true" PageSize="5" OnPageIndexChanging="GridView1_PageIndexChanging" Height="100%" Width="100%">
            <Columns>
                <asp:BoundField DataField="订单号" HeaderText="订单号" ReadOnly="True" SortExpression="订单号">
                <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="付款时间" DataFormatString="{0:d}" HeaderText="付款时间" SortExpression="付款时间">
                <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="商品名称" HeaderText="商品名称" SortExpression="商品名称">
                <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="数量" HeaderText="数量" SortExpression="数量">
                <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="总价" HeaderText="总价" SortExpression="总价">
                <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="状态" HeaderText="状态" SortExpression="状态">
                <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                </asp:BoundField>
                 <asp:BoundField DataField="用户" HeaderText="用户" SortExpression="用户">
                <FooterStyle HorizontalAlign="Center" VerticalAlign="Middle" />

                </asp:BoundField>
            </Columns>


            <RowStyle Height="46px" HorizontalAlign="Center" />


        </asp:GridView>
      </td>
  </tr>
</table>
    </div>
       
      	<div class="footer">
    <p>Copyright ©2019  All Rights Reserved</p> 
     </div>
    </div>
    
           </center>
</div> 
        
  
    </form>
  
</body>
</html>
